<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>For SQLite: GNOME Data Access 5 manual</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.79.1">
<link rel="home" href="index.html" title="GNOME Data Access 5 manual">
<link rel="up" href="limitations.html" title="Limitations">
<link rel="prev" href="limitations_postgres.html" title="For PostgreSQL">
<link rel="next" href="limitations_sqlcipher.html" title="For SQLCipher">
<meta name="generator" content="GTK-Doc V1.32 (XML mode)">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="5"><tr valign="middle">
<td width="100%" align="left" class="shortcuts"></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="16" height="16" border="0" alt="Home"></a></td>
<td><a accesskey="u" href="limitations.html"><img src="up.png" width="16" height="16" border="0" alt="Up"></a></td>
<td><a accesskey="p" href="limitations_postgres.html"><img src="left.png" width="16" height="16" border="0" alt="Prev"></a></td>
<td><a accesskey="n" href="limitations_sqlcipher.html"><img src="right.png" width="16" height="16" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="limitations_sqlite"></a>For SQLite</h2></div></div></div>
<p>
      The following limitations apply to SQLite databases accessed via Libgda:
    </p>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.3"></a>Last inserted row's values</h3></div></div></div>
<p>
	The <a class="link" href="GdaConnection.html#gda-connection-statement-execute-non-select" title="gda_connection_statement_execute_non_select ()">gda_connection_statement_execute_non_select()</a>'s last_insert_row attribute uses the hidden "_ROWID_" column for each table, but it may fail if the table has a column with the same name.
      </p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.4"></a>Date and time</h3></div></div></div>
<p>
	As SQLite stores dates and times as strings, <span class="application">Libgda</span> only handles dates in the format recommended by SQLite,
	which is "YYYY-MM-DD" for dates, "HH:MM:SS" for times and "YYYY-MM-DD HH:MM:SS" for timestamps (see 
	<a class="ulink" href="http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions" target="_top">SQLite's documentation</a>).
      </p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.5"></a>Timezone information</h3></div></div></div>
<p>
	Timezone information associated with time and timestamp data types is not stored by PostgreSQL, so when executing
	statements all the variables containing a time or timestamp information are converted to GMT (timezone 0) before
	the execution happens. The consequence is that for example if a variable holds the "11:23:55+2" time (11 hours,
	23 minutes and 55 seconds, at GMT + 2), then the actual time stored in the database will be "09:23:55", the same
	time but GMT.
      </p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.6"></a>Multi threaded environment</h3></div></div></div>
<p>
	No limitation if sqlite has been compiled with the SQLITE_THREADSAFE=1 flag (which is the case for the
	embedded version of SQLite). If the system installed SQLite is used and if it was not compiled using that
	flag, then <span class="application">Libgda</span> sets the SQLite library in a state where multi threading is fully supported.
      </p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.12.6.7"></a>Error reporting</h3></div></div></div>
<p>
	If there is not enough free space on the disk which stores an SQLite database, you may have some
	"Disk I/O error" errors. This is also true for meta data connections which are by default
	created in a temporary location.
      </p>
</div>
</div>
<div class="footer">
<hr>Generated by GTK-Doc V1.32</div>
</body>
</html>